/* 가게 QA 테이블	*/
/* BY 기석 */
CREATE table SHOP_QA (
	qa_seq number not null,				--게시판 질문 번호
	shop_num number not null,			--가게 번호
	id varchar2(20) not null,			--작성자ID
	qa_title varchar2(100),				--질문 제목
	qa_contents varchar2(1000),			--질문 내용
	qa_inputdate date					--질문 작성시간
);

CREATE SEQUENCE QA_SEQUENCE INCREMENT BY 1 START WITH 1;



/* 스팸 금칙어 관리 테이블 by 기석*/

create table spam(
spam_seq number primary key,
shop_seq number not null,
keywords varchar2(30) not null
);

alter table spam add
	foreign key (shop_seq)
	references shop (shop_seq)
;

 create sequence SEQ_spam_spam_seq increment by 1 start with 1;

 
 insert into spam values(SEQ_spam_spam_seq.nextval,24,'야옹');
 insert into spam values(SEQ_spam_spam_seq.nextval,6,'야옹');
 insert into spam values(SEQ_spam_spam_seq.nextval,6,'멍멍');
 